Endpoint Delete [Dynamic Endpoint]

Name

delete_[dynamic_endpoint_name]

Description

No description available [API reference]

Related Tables

[Dynamic Table]

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Zoho CRM Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Zoho CRM

Read and write Zoho CRM data effortlessly. Integrate, manage, and automate accounts, leads, contacts, and deals — almost no coding required.

Zoho CRM

Delete [Dynamic Endpoint]

Required Parameters
Record ID(s) - Use Comma for multiple (e.g. 111,222)	Fill-in the parameter...
Optional Parameters
Fire Wordflow Trigger

API Destination

This Endpoint belongs to the [Dynamic Table] table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to delete [dynamic endpoint]:

API Destination - Zoho CRM

Read and write Zoho CRM data effortlessly. Integrate, manage, and automate accounts, leads, contacts, and deals — almost no coding required.

Zoho CRM

[Dynamic Table]

Delete

Required Parameters
Record ID(s) - Use Comma for multiple (e.g. 111,222)	Fill-in the parameter...
Optional Parameters
Fire Wordflow Trigger

ODBC application

Use these SQL queries in your ODBC application data source:

Delete an account

<p>Deletes a single Account record by its ID. This example demonstrates using the <code>DELETE FROM</code> statement with a <code>WHERE</code> clause specifying the record ID.</p>

DELETE FROM Accounts WHERE id=11111111111

Delete accounts in bulk

<p>Deletes multiple Account records by specifying a list of IDs. This example demonstrates passing a comma-separated list of IDs to the <code>Id</code> parameter in the <code>WITH</code> clause (up to 100 IDs).</p>

DELETE FROM Accounts WITH(Id='11111,22222,33333')

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Delete an account

<p>Deletes a single Account record by its ID. This example demonstrates using the <code>DELETE FROM</code> statement with a <code>WHERE</code> clause specifying the record ID.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Accounts WHERE id=11111111111';

EXEC (@MyQuery) AT [LS_TO_ZOHO_CRM_IN_GATEWAY];

Delete accounts in bulk

<p>Deletes multiple Account records by specifying a list of IDs. This example demonstrates passing a comma-separated list of IDs to the <code>Id</code> parameter in the <code>WITH</code> clause (up to 100 IDs).</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Accounts WITH(Id=''11111,22222,33333'')';

EXEC (@MyQuery) AT [LS_TO_ZOHO_CRM_IN_GATEWAY];